create database TestDB
on
(  name='shuju1',
   filename='D:\abc\TestDB.mdf',
   size=10mb,
   filegrowth=2mb,
   maxsize=100mb
)
log on
(  name='shuju1.day',
   filename='D:\abc\TestDB.day.ldf',
   size=10mb,
   filegrowth=2mb,
   maxsize=100mb
)
go
use TestDB
go

create table typeInfo
(
  typeId int identity(1,1) primary key,
  typename varchar(10) not null
)
go
create table loginInfo
(
  LoginId int identity(1000,1) primary key,
  LoginName nvarchar(10) not null unique,
  LoginPwd nvarchar(20) not null default('123456'),
  LoginpwdSex char(2) ,
  LoginBirthday datetime,
  Loginvip int,
)
